If you switched off the light, it means that you have come to an end of the important project or life event. The dream could also indicate the shortage of seeing things. Perhaps you feel as being in the dark and unable to understand situation clearly.
Dream dictionary: Light switch (on) dream meanings
To dream that you turned the light on means that youve got a new idea or you finally realized something you havent been able to do it before.